Delete Column
AutomatR.Excel.Activities.DeleteColumn
The "Delete Column" activity in AutomatR is part of the Excel activities package, specifically designed for deleting a table column from a spreadsheet based on its name. This activity streamlines data manipulation tasks in Excel, enhancing the efficiency of automation workflows.
Properties
| Name | Description |
|---|---|
| Input | |
| Column Index | Enter the index for the column which needs to be deleted. Integer variables containing the column index. |
| Table Name | Enter the table name. String variables containing the table name. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Delete Column" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Delete Column" activity onto the workflow.
- Configure the properties by specifying the table name and the index of the column to be deleted.
- Optionally, configure the delay.
- Execute the workflow to delete the specified column within the Excel workbook.
Example: Consider an example where the "Delete Column" activity is used to delete the column at index 3 from a table named "SalesTable" with a 2-second delay:
Delete Column:
Table Name: "SalesTable"
Column Index: 3
Delay: 2
In this example, the activity deletes the column at index 3 from the "SalesTable" within the Excel workbook, allowing time for any necessary cleanup or synchronization.